lyfz_repos/铂金版源码/DBFile/SQL/2015-08-13[收集]/任务交办SQL.txt

--创建任务交办表
create table tb_ErpShopAssignmente(
ID int identity(1,1) not null,--备注ID
Agt_Priority int not null,--任务优先级 0 为高 1 为中 2 为低
Agt_PublishName nvarchar(20) not null,--发布人
Agt_PublishTime datetime not null,--发布时间
Agt_Content nvarchar(200) not null,--发布的任务内容
Agt_ManageName nvarchar(20) not null,--办理人
Agt_CompleteTime datetime not null,--完成时间
Agt_CompleteStatus int not null,--任务的完成状态 0 为待执行 1 为执行中 2 为已完成 3 为已搁置 4 为无法完成 5 为延后
Agt_Summary nvarchar(200) not null,--任务内容
Agt_Revert nvarchar(200) not null,--发布者的回复
Agt_CreateDatetime datetime not null,--创建的时间
Agt_CreateName nvarchar(20) not null,--创建人
Agt_UpdateDatetime datetime not null,--修改日期
Agt_UpdateName nvarchar(20) not null--修改人
)

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务交办表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente'
 

--EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'ID'
--GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务优先级 0 为高 1 为中 2 为低' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布人' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_PublishName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_PublishTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布的任务内容' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_Content'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'办理人' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_ManageName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'完成时间' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_CompleteTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务的完成状态 0 为待执行 1 为执行中 2 为已完成 3 为已搁置 4 为无法完成 5 为延后' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_CompleteStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务内容' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_Summary'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布者的回复' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_Revert'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建的时间' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_CreateDatetime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_CreateName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_UpdateDatetime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopAssignmente', @level2type=N'COLUMN',@level2name=N'Agt_UpdateName'
GO

--创建任务报告表
create table tb_ErpShopDebriefing(
Rpt_ID int identity(1,1) not null,--任务交办表关联
Rpt_CompleteState int not null,--任务的完成状态 0 为待执行 1 为执行中 2 为已完成 3 为已搁置 4 为无法完成 5 为延后
Rpt_Summary nvarchar(200) not null,--任务内容
Rpt_CreateDatetime datetime not null,--创建的时间
Rpt_UpdateName nvarchar(20) not null--修改人
)
go
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务交办表关联' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopDebriefing', @level2type=N'COLUMN',@level2name=N'Rpt_ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务的完成状态 0 为待执行 1 为执行中 2 为已完成 3 为已搁置 4 为无法完成 5 为延后' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopDebriefing', @level2type=N'COLUMN',@level2name=N'Rpt_CompleteState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务内容' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopDebriefing', @level2type=N'COLUMN',@level2name=N'Rpt_Summary'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , 
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_ErpShopDebriefing', @level2type=N'COLUMN',@level2name=N'Rpt_UpdateName'
GO